USE [demo]
GO
/****** Object:  Table [dbo].[LOG_PROCEDURE]    Script Date: 06/12/2011 21:14:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_PROCEDURE](
	[LOG_PROCEDURE_GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_OG_PRODECURE_LOG_PROCEDURE_GUID]  DEFAULT (newid()),
	[LOG_PRODECURE_TIME] [datetime] NOT NULL CONSTRAINT [DF_OG_PRODECURE_LOG_PRODECURE_TIME]  DEFAULT (getdate()),
	[LOG_PROCEDURE_ID] [int] IDENTITY(1,1) NOT NULL,
	[LOG_ID] [int] NOT NULL,
	[ACTION_NAME] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[STEP] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[DESCRIPTION] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[COMMAND] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NULL,
	[STATUS] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL
) ON [PRIMARY]
